# -*- coding: utf-8 -*-
from sqlalchemy import Column, String, Integer, Text, Binary, Boolean, DateTime, Enum, Float
from adminApp.extensions import db
from .base import BaseModel


class Broadbandccount(BaseModel, db.Model):
    # 宽带账号
    name = db.Column(db.String(128), nullable=False)
    # 密码
    password = db.Column(db.String(100))
    vlan = db.Column(Integer)
    # 上行带宽
    upstream_bandwidth = db.Column(Integer)
    # 下行带宽
    downstream_bandwidth = db.Column(Integer)
    # 区域
    area = db.Column(db.String(200), index=True)
    # 拨数 多拨数目
    dial_number = db.Column(db.Integer, default=1, nullable=False, index=True)
    # 开通日期
    start_date = db.Column(db.Date, index=True)
    # 结束日期
    stop_date = db.Column(db.Date, index=True)
    # 备注
    remark = db.Column(db.Text)
    # 总分配记录数
    all_dist_num = db.Column(db.Integer, index=True)
    # 当前分配记录数
    now_dist_num = db.Column(db.Integer, index=True)